CREATE TABLE [dbo].[Product_FR]
(
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_FR_PRODUCT_CODE] DEFAULT (''),
[AMOUNT_TO_QUALIFY] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Product_FR_AMOUNT_TO_QUALIFY] DEFAULT ((0)),
[DATE_RANGE_CRITERION] [tinyint] NOT NULL CONSTRAINT [DF_Product_FR_DATE_RANGE_CRITERION] DEFAULT ((0)),
[NUMBER_OF_DAYS] [int] NOT NULL CONSTRAINT [DF_Product_FR_NUMBER_OF_DAYS] DEFAULT ((0)),
[ONLY_FOR_FUND] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_FR_ONLY_FOR_FUND] DEFAULT (''),
[ONLY_FOR_CAMPAIGN] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_FR_ONLY_FOR_CAMPAIGN] DEFAULT (''),
[ONLY_FOR_APPEAL] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_FR_ONLY_FOR_APPEAL] DEFAULT (''),
[LETTER_TITLE] [varchar] (45) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IS_CASH_ONLY] [tinyint] NOT NULL CONSTRAINT [DF_Product_FR_IS_CASH_ONLY] DEFAULT ((0)),
[FR_TYPE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_FR_FR_TYPE] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iProduct_FRTYPE] ON [dbo].[Product_FR] ([FR_TYPE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Product_FR] TO [IMIS]
GRANT SELECT ON  [dbo].[Product_FR] TO [IMIS]
GRANT INSERT ON  [dbo].[Product_FR] TO [IMIS]
GRANT DELETE ON  [dbo].[Product_FR] TO [IMIS]
GRANT UPDATE ON  [dbo].[Product_FR] TO [IMIS]
GO